Melissa Yamada
Melissa Yamada
-
Re: Conditional Formatting on Multiple Sheets
Hello @Lisa McMunn Try this: Create a helper column (for example checkbox "Training Done" column) on your Associate Information Sheet Add this formula: =IF(HAS({Badge # Column in Training T…1 · -
Re: Percent column adds two zeros
Hello @noshiro Format first your % complete column to percentage. Then add your calculations. For example: =[Column 1]@row / [Column 2]@row If you're manually adding data on the % complete column, no…1 · -
Re: Index IF formula for data in Row bases on Column data
Hello @Marielitos If you're going through the path of using formulas, you'll need to create the formula on each column on your destination sheet. Also, I think you'd want to use INDEX/COLLECT functio…1 · -
Re: Did changing the column title permanently break the formula from sheet to sheet?
Hello @PhyllisB Since you're using a multi-select dropdown on your source sheet, your current formula doesn't count rows with multiple values. In this case, you'll need to incorporate the HAS functio…1 · -
Re: Average of Color Symbols (RYG) on same row
Hello @SherryFox Try this: =IF(COUNTIF(Cost1:Performance1, "Red") = COUNT(Cost1:Performance1), "Red", IF(COUNTIF(Cost1:Performance1, "Green") = COUNT(Cost1:Performance1)…1 ·
